<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE hibernate-mapping PUBLIC
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN" 
    "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
    <class name="cn.firstsoft.modules.emp.domain.EmpCertificate" table="emp_certificate">
      <id name="id" type="integer">
            <column name="id" />
            <generator class="native" >
				         <param name="sequence">EMP_CERTIFICATE_ID_SEQ</param>
            </generator>
        </id>

        <property name="type" type="string">
            <column name="type" length="50" />
        </property>

        <property name="sendDate" type="timestamp">
            <column name="send_date" length="23"/>
        </property>

        <property name="endDate" type="timestamp">
           <column name="end_date" length="23"/>
        </property>

        <property name="useDate" type="double">
            <column name="use_date"/>
        </property>
        <property name="useDay" type="integer">
           <column name="use_day"/>
        </property>

        <property name="department" type="string">
           <column name="department" length="50" />
        </property>

        <property name="linkTel" type="string">
           <column name="link_tel" length="50" />
        </property>

        <many-to-one name="employee" class="cn.firstsoft.modules.emp.domain.Employee" fetch="select">
         <column name="emp_id"/>
        </many-to-one>
    </class>
</hibernate-mapping>
